﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsDiaChi" targetNamespace="http://tempuri.org/dsDiaChi.xsd" xmlns:mstns="http://tempuri.org/dsDiaChi.xsd" xmlns="http://tempuri.org/dsDiaChi.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblQuanHuyenTableAdapter" GeneratorDataComponentClassName="tblQuanHuyenTableAdapter" Name="tblQuanHuyen" UserDataComponentName="tblQuanHuyenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblQuanHuyen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblQuanHuyen] WHERE (([QuanHuyenID] = @Original_QuanHuyenID) AND ((@IsNull_TinhThanhID = 1 AND [TinhThanhID] IS NULL) OR ([TinhThanhID] = @Original_TinhThanhID)) AND ((@IsNull_TenQuanHuyen = 1 AND [TenQuanHuyen] IS NULL) OR ([TenQuanHuyen] = @Original_TenQuanHuyen)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenQuanHuyen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenQuanHuyen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenQuanHuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenQuanHuyen" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblQuanHuyen] ([TinhThanhID], [TenQuanHuyen]) VALUES (@TinhThanhID, @TenQuanHuyen);
SELECT QuanHuyenID, TinhThanhID, TenQuanHuyen FROM tblQuanHuyen WHERE (QuanHuyenID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenQuanHuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenQuanHuyen" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT QuanHuyenID, TinhThanhID, TenQuanHuyen FROM dbo.tblQuanHuyen</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblQuanHuyen] SET [TinhThanhID] = @TinhThanhID, [TenQuanHuyen] = @TenQuanHuyen WHERE (([QuanHuyenID] = @Original_QuanHuyenID) AND ((@IsNull_TinhThanhID = 1 AND [TinhThanhID] IS NULL) OR ([TinhThanhID] = @Original_TinhThanhID)) AND ((@IsNull_TenQuanHuyen = 1 AND [TenQuanHuyen] IS NULL) OR ([TenQuanHuyen] = @Original_TenQuanHuyen)));
SELECT QuanHuyenID, TinhThanhID, TenQuanHuyen FROM tblQuanHuyen WHERE (QuanHuyenID = @QuanHuyenID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenQuanHuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenQuanHuyen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenQuanHuyen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenQuanHuyen" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenQuanHuyen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenQuanHuyen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="QuanHuyenID" ColumnName="QuanHuyenID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="QuanHuyenID" DataSetColumn="QuanHuyenID" />
              <Mapping SourceColumn="TinhThanhID" DataSetColumn="TinhThanhID" />
              <Mapping SourceColumn="TenQuanHuyen" DataSetColumn="TenQuanHuyen" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblQuanHuyen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT QuanHuyenID, TinhThanhID, TenQuanHuyen FROM dbo.tblQuanHuyen
where TinhThanhID=@tinh</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="tinh" ColumnName="TinhThanhID" DataSourceName="CrewManagment.dbo.tblQuanHuyen" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@tinh" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblPhuongXaTableAdapter" GeneratorDataComponentClassName="tblPhuongXaTableAdapter" Name="tblPhuongXa" UserDataComponentName="tblPhuongXaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblPhuongXa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblPhuongXa] WHERE (([PhuongXaID] = @Original_PhuongXaID) AND ((@IsNull_QuanHuyenID = 1 AND [QuanHuyenID] IS NULL) OR ([QuanHuyenID] = @Original_QuanHuyenID)) AND ((@IsNull_TenPhuongXa = 1 AND [TenPhuongXa] IS NULL) OR ([TenPhuongXa] = @Original_TenPhuongXa)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhuongXaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenPhuongXa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenPhuongXa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenPhuongXa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenPhuongXa" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblPhuongXa] ([QuanHuyenID], [TenPhuongXa]) VALUES (@QuanHuyenID, @TenPhuongXa);
SELECT PhuongXaID, QuanHuyenID, TenPhuongXa FROM tblPhuongXa WHERE (PhuongXaID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenPhuongXa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenPhuongXa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PhuongXaID, QuanHuyenID, TenPhuongXa FROM dbo.tblPhuongXa</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblPhuongXa] SET [QuanHuyenID] = @QuanHuyenID, [TenPhuongXa] = @TenPhuongXa WHERE (([PhuongXaID] = @Original_PhuongXaID) AND ((@IsNull_QuanHuyenID = 1 AND [QuanHuyenID] IS NULL) OR ([QuanHuyenID] = @Original_QuanHuyenID)) AND ((@IsNull_TenPhuongXa = 1 AND [TenPhuongXa] IS NULL) OR ([TenPhuongXa] = @Original_TenPhuongXa)));
SELECT PhuongXaID, QuanHuyenID, TenPhuongXa FROM tblPhuongXa WHERE (PhuongXaID = @PhuongXaID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenPhuongXa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenPhuongXa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhuongXaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuanHuyenID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenPhuongXa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenPhuongXa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenPhuongXa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenPhuongXa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PhuongXaID" ColumnName="PhuongXaID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@PhuongXaID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="PhuongXaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PhuongXaID" DataSetColumn="PhuongXaID" />
              <Mapping SourceColumn="QuanHuyenID" DataSetColumn="QuanHuyenID" />
              <Mapping SourceColumn="TenPhuongXa" DataSetColumn="TenPhuongXa" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblPhuongXa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT PhuongXaID, QuanHuyenID, TenPhuongXa FROM dbo.tblPhuongXa
where QuanHuyenID=@quan</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="quan" ColumnName="QuanHuyenID" DataSourceName="CrewManagment.dbo.tblPhuongXa" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@quan" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="QuanHuyenID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblTinhThanhTableAdapter" GeneratorDataComponentClassName="tblTinhThanhTableAdapter" Name="tblTinhThanh" UserDataComponentName="tblTinhThanhTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblTinhThanh" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblTinhThanh] WHERE (([TinhThanhID] = @Original_TinhThanhID) AND ((@IsNull_TenTinhThanh = 1 AND [TenTinhThanh] IS NULL) OR ([TenTinhThanh] = @Original_TenTinhThanh)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenTinhThanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenTinhThanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenTinhThanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenTinhThanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblTinhThanh] ([TenTinhThanh]) VALUES (@TenTinhThanh);
SELECT TinhThanhID, TenTinhThanh FROM tblTinhThanh WHERE (TinhThanhID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenTinhThanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenTinhThanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT TinhThanhID, TenTinhThanh FROM dbo.tblTinhThanh</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblTinhThanh] SET [TenTinhThanh] = @TenTinhThanh WHERE (([TinhThanhID] = @Original_TinhThanhID) AND ((@IsNull_TenTinhThanh = 1 AND [TenTinhThanh] IS NULL) OR ([TenTinhThanh] = @Original_TenTinhThanh)));
SELECT TinhThanhID, TenTinhThanh FROM tblTinhThanh WHERE (TinhThanhID = @TinhThanhID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TenTinhThanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenTinhThanh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenTinhThanh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenTinhThanh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TenTinhThanh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TenTinhThanh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="TinhThanhID" ColumnName="TinhThanhID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TinhThanhID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TinhThanhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TinhThanhID" DataSetColumn="TinhThanhID" />
              <Mapping SourceColumn="TenTinhThanh" DataSetColumn="TenTinhThanh" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsDiaChi" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsDiaChi" msprop:Generator_UserDSName="dsDiaChi">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblQuanHuyen" msprop:Generator_TableClassName="tblQuanHuyenDataTable" msprop:Generator_TableVarName="tabletblQuanHuyen" msprop:Generator_TablePropName="tblQuanHuyen" msprop:Generator_RowDeletingName="tblQuanHuyenRowDeleting" msprop:Generator_UserTableName="tblQuanHuyen" msprop:Generator_RowChangingName="tblQuanHuyenRowChanging" msprop:Generator_RowEvHandlerName="tblQuanHuyenRowChangeEventHandler" msprop:Generator_RowDeletedName="tblQuanHuyenRowDeleted" msprop:Generator_RowEvArgName="tblQuanHuyenRowChangeEvent" msprop:Generator_RowChangedName="tblQuanHuyenRowChanged" msprop:Generator_RowClassName="tblQuanHuyenRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="QuanHuyenID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnQuanHuyenID" msprop:Generator_ColumnPropNameInRow="QuanHuyenID" msprop:Generator_ColumnPropNameInTable="QuanHuyenIDColumn" msprop:Generator_UserColumnName="QuanHuyenID" type="xs:int" />
              <xs:element name="TinhThanhID" msprop:Generator_ColumnVarNameInTable="columnTinhThanhID" msprop:Generator_ColumnPropNameInRow="TinhThanhID" msprop:Generator_ColumnPropNameInTable="TinhThanhIDColumn" msprop:Generator_UserColumnName="TinhThanhID" type="xs:int" minOccurs="0" />
              <xs:element name="TenQuanHuyen" msprop:Generator_ColumnVarNameInTable="columnTenQuanHuyen" msprop:Generator_ColumnPropNameInRow="TenQuanHuyen" msprop:Generator_ColumnPropNameInTable="TenQuanHuyenColumn" msprop:Generator_UserColumnName="TenQuanHuyen" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblPhuongXa" msprop:Generator_TableClassName="tblPhuongXaDataTable" msprop:Generator_TableVarName="tabletblPhuongXa" msprop:Generator_TablePropName="tblPhuongXa" msprop:Generator_RowDeletingName="tblPhuongXaRowDeleting" msprop:Generator_UserTableName="tblPhuongXa" msprop:Generator_RowChangingName="tblPhuongXaRowChanging" msprop:Generator_RowEvHandlerName="tblPhuongXaRowChangeEventHandler" msprop:Generator_RowDeletedName="tblPhuongXaRowDeleted" msprop:Generator_RowEvArgName="tblPhuongXaRowChangeEvent" msprop:Generator_RowChangedName="tblPhuongXaRowChanged" msprop:Generator_RowClassName="tblPhuongXaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PhuongXaID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnPhuongXaID" msprop:Generator_ColumnPropNameInRow="PhuongXaID" msprop:Generator_ColumnPropNameInTable="PhuongXaIDColumn" msprop:Generator_UserColumnName="PhuongXaID" type="xs:int" />
              <xs:element name="QuanHuyenID" msprop:Generator_ColumnVarNameInTable="columnQuanHuyenID" msprop:Generator_ColumnPropNameInRow="QuanHuyenID" msprop:Generator_ColumnPropNameInTable="QuanHuyenIDColumn" msprop:Generator_UserColumnName="QuanHuyenID" type="xs:int" minOccurs="0" />
              <xs:element name="TenPhuongXa" msprop:Generator_ColumnVarNameInTable="columnTenPhuongXa" msprop:Generator_ColumnPropNameInRow="TenPhuongXa" msprop:Generator_ColumnPropNameInTable="TenPhuongXaColumn" msprop:Generator_UserColumnName="TenPhuongXa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblTinhThanh" msprop:Generator_TableClassName="tblTinhThanhDataTable" msprop:Generator_TableVarName="tabletblTinhThanh" msprop:Generator_TablePropName="tblTinhThanh" msprop:Generator_RowDeletingName="tblTinhThanhRowDeleting" msprop:Generator_UserTableName="tblTinhThanh" msprop:Generator_RowChangingName="tblTinhThanhRowChanging" msprop:Generator_RowEvHandlerName="tblTinhThanhRowChangeEventHandler" msprop:Generator_RowDeletedName="tblTinhThanhRowDeleted" msprop:Generator_RowEvArgName="tblTinhThanhRowChangeEvent" msprop:Generator_RowChangedName="tblTinhThanhRowChanged" msprop:Generator_RowClassName="tblTinhThanhRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TinhThanhID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnTinhThanhID" msprop:Generator_ColumnPropNameInRow="TinhThanhID" msprop:Generator_ColumnPropNameInTable="TinhThanhIDColumn" msprop:Generator_UserColumnName="TinhThanhID" type="xs:int" />
              <xs:element name="TenTinhThanh" msprop:Generator_ColumnVarNameInTable="columnTenTinhThanh" msprop:Generator_ColumnPropNameInRow="TenTinhThanh" msprop:Generator_ColumnPropNameInTable="TenTinhThanhColumn" msprop:Generator_UserColumnName="TenTinhThanh" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblQuanHuyen" />
      <xs:field xpath="mstns:QuanHuyenID" />
    </xs:unique>
    <xs:unique name="tblPhuongXa_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblPhuongXa" />
      <xs:field xpath="mstns:PhuongXaID" />
    </xs:unique>
    <xs:unique name="tblTinhThanh_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblTinhThanh" />
      <xs:field xpath="mstns:TinhThanhID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblQuanHuyen_tblTinhThanh" msdata:parent="tblTinhThanh" msdata:child="tblQuanHuyen" msdata:parentkey="TinhThanhID" msdata:childkey="TinhThanhID" msprop:Generator_UserChildTable="tblQuanHuyen" msprop:Generator_ChildPropName="GettblQuanHuyenRows" msprop:Generator_ParentPropName="tblTinhThanhRow" msprop:Generator_UserRelationName="FK_tblQuanHuyen_tblTinhThanh" msprop:Generator_RelationVarName="relationFK_tblQuanHuyen_tblTinhThanh" msprop:Generator_UserParentTable="tblTinhThanh" />
      <msdata:Relationship name="FK_tblPhuongXa_tblQuanHuyen" msdata:parent="tblQuanHuyen" msdata:child="tblPhuongXa" msdata:parentkey="QuanHuyenID" msdata:childkey="QuanHuyenID" msprop:Generator_UserChildTable="tblPhuongXa" msprop:Generator_ChildPropName="GettblPhuongXaRows" msprop:Generator_ParentPropName="tblQuanHuyenRow" msprop:Generator_UserRelationName="FK_tblPhuongXa_tblQuanHuyen" msprop:Generator_RelationVarName="relationFK_tblPhuongXa_tblQuanHuyen" msprop:Generator_UserParentTable="tblQuanHuyen" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>